CREATE TABLE [dbo].[TTTIPO_FATE]
(
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[TI_FACT] [dbo].[TD_VC_003] NOT NULL,
[DE_TIPO_FACT] [dbo].[TD_VC_100] NULL,
[CO_USUA_CREA] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TTTIPO_FA__CO_US__2B554987] DEFAULT (suser_sname()),
[FE_USUA_CREA] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TTTIPO_FA__FE_US__2C496DC0] DEFAULT (getdate()),
[CO_USUA_MODI] [dbo].[TD_VC_008_USUA] NOT NULL CONSTRAINT [DF__TTTIPO_FA__CO_US__2D3D91F9] DEFAULT (suser_sname()),
[FE_USUA_MODI] [dbo].[TD_DT_001_SIST] NOT NULL CONSTRAINT [DF__TTTIPO_FA__FE_US__2E31B632] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TTTIPO_FATE] ADD CONSTRAINT [PK__TTTIPO_F__95F06D8432774862] PRIMARY KEY CLUSTERED  ([CO_EMPR], [TI_FACT]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TTTIPO_FATE] ADD CONSTRAINT [FK__TTTIPO_FA__CO_EM__77AB884F] FOREIGN KEY ([CO_EMPR]) REFERENCES [dbo].[TMPARA_TESO] ([CO_EMPR])
GO
